SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
AND list_price BETWEEN '1000000' AND '99999999'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:7 WILLOW SPRING LANE- Spacious, well-maintained home on a large private lot in a quiet neighborhood within walking distance of downtown Hanover. The Girl Brook Trail and Dartmouth's Practice Golf Course are adjacent the property providing acres of space to recreate. The house interiors are spacious and bright, including a large living room with central fireplace and views over the back lawn on the main level. There is a large, well-appointed eat-in kitchen that adjoins a formal dining room, while the primary bedroom suite on this level features a generous en suite bathroom, changing area, and plenty of wardrobe space. There is also a second en suite bedroom on this floor providing plenty of options for one-floor living. The lower walkout level offers several versatile bright and spacious rooms including a family room, rec room, and two additional bedrooms that share a full bathroom. Additionally, there is a large central laundry room, workshop, and additional storage space. Outside the home are level lawns, mature landscaping, and a sizable deck to enjoy during warmer weather. With walking trails, cross country skiing, and more on the Girl Brook Trail network and shops, restaurants, and area schools just minutes away, this charming family home is a true Hanover gem. A few photos are virtually staged.
Description:Welcome to this charming 3-bedroom, 2 1/2-bath home in the heart of Hanover, NH! Perfectly situated within walking distance to both downtown and Dartmouth College, this property offers the best of convenience and comfort. As you enter, you'll immediately appreciate the spacious and inviting atmosphere, highlighted by a large family room that's perfect for gatherings or relaxation. The living room features a cozy fireplace, creating a warm, welcoming space during the colder months. Natural light flows throughout the home, enhancing the open, airy feel. The second-floor laundry adds convenience to your daily routine. Each of the three bedrooms is generously sized, providing a peaceful retreat at the end of the day. Another room on the ground floor is great as an office or guest space. Enjoy the serenity of a screened-in porch, ideal for enjoying your morning coffee or unwinding after a busy day. The property is also close to trails, offering endless opportunities for outdoor activities, from hiking to biking, just steps from your door. The attached 2 car garage has direct access to a big mudroom and part of the full basement could be finished if you want even more space. This home offers the perfect blend of modern amenities, including central air conditioning, prime location, and outdoor access. Don’t miss your chance to experience all that Hanover has to offer – schedule your tour today! Public Open House Saturday April 12, 11:00 a.m. - 1:00 p.m.
Description:Welcome to the best of golf course living! This upscale home on Eastman Golf Links is on the market for the very first time. A custom Yankee Barn home on the 2nd fairway with golf course views throughout many rooms. This spacious 4,397 SF home offers sleeping quarters on each of its 3 finished levels. Featuring a statement living room with cathedral ceilings, a 2-story window display, double-sided fireplace, and the quintessential wood beams highlighting its architecture. A beautiful kitchen with an island and stainless steel appliances sits opposite the dining area with sliders to a cozy sunroom. Retreat to the main level Primary bedroom suite with its own bath and deck access. You’ll also find an office with skylights, family room with deck access, and a half bath on the main level. The upper level has a loft area + 2 bedrooms and a full bath with separate tub and shower. The finished walkout lower level is an expansive space for gatherings and game nights. It includes a family room area with built-ins, a wet bar with seating, a built-in desk with storage, and a rec area. This grand home is complete with a 2-car attached garage, tiled mudroom, level lot and paved driveway. Eastman offers lake activities, golf, cross-country skiing, tennis, pickleball, walking trails, an indoor pool, fitness center and more. All this in the heart of the Dartmouth - Lake Sunapee Region with easy access to I-89.
Description:Mastlands, named for the towering Eastern white pines once used as ship masts, is a historic Cornish Art Colony estate nestled among trees, farmland, and exquisite gardens. Once the summer home of Dr. Arthur Nichols and his family, it carries a rich legacy, with his daughter, Rose Nichols - a prominent landscape architect - designing the walled garden off the piazza, inspired by her uncle Augustus Saint-Gaudens and architect Charles Platt. The estate's 24 acres feature revived gardens, seasonal blooms, restored fountains, and peaceful retreats like Pine Tree Alley and a firepit. The property offers great outdoor opportunities, with access to a nearby Class 4 road connecting to the scenic River Road, ideal for walks, and additional paths around the cornfields for leisurely strolls. The grand living spaces featuring high ceilings and intricate moldings, including a ballroom wing with elements salvaged from a European chateau, combine historic charm with modern comforts and is crafted for sharing with loved ones. A versatile one-bedroom apartment offers independent living or rental potential, making Mastlands a perfect home for those who cherish history and seek to continue its stewardship. Showings begin 9/3.
Description:Beautifully designed and meticulously crafted contemporary cape in a private country setting. Bright sunshine fills this home adding to the atmosphere of complete comfort. Large family room is open to the excellent kitchen, there is a formal dining room with more built-ins and a gorgeous vaulted ceiling living room with fireplace. Cozy sunroom completes the first floor. Upstairs there's a gracious primary suite with balcony, 2 more bedroom, a quiet study and a convenient laundry room. The grounds are fantastic with mature gardens which can be enjoyed from the spacious covered front porch, deck off the kitchen or the stone patio. A wonderful Post and Beam barn is perfect for a workshop, antique car storage or studio space. A very special offering! Showings begin Wednesday, March 12th.